{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "mechanical-welding",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "furnished-barcelona",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_excel(r'D:\\Programming\\Python\\PlayTogether_Data\\book3_pandas\\class12_readExcel\\house.xlsx', engine='openpyxl')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "interstate-cancer",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>链家网址</th>\n",
       "      <th>id</th>\n",
       "      <th>所在社区编号</th>\n",
       "      <th>交易时间</th>\n",
       "      <th>挂牌天数</th>\n",
       "      <th>关注人数</th>\n",
       "      <th>总价</th>\n",
       "      <th>平米均价</th>\n",
       "      <th>面积</th>\n",
       "      <th>卧室</th>\n",
       "      <th>客厅</th>\n",
       "      <th>厨房</th>\n",
       "      <th>浴室</th>\n",
       "      <th>楼层信息</th>\n",
       "      <th>建成时间</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101492812....</td>\n",
       "      <td>101101492812</td>\n",
       "      <td>1111027377718</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>259</td>\n",
       "      <td>226</td>\n",
       "      <td>380.0</td>\n",
       "      <td>47560</td>\n",
       "      <td>79.90</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 6</td>\n",
       "      <td>2004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101594408....</td>\n",
       "      <td>101101594408</td>\n",
       "      <td>1111027379032</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>231</td>\n",
       "      <td>9</td>\n",
       "      <td>507.0</td>\n",
       "      <td>36071</td>\n",
       "      <td>140.56</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>中 6</td>\n",
       "      <td>2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101601669....</td>\n",
       "      <td>101101601669</td>\n",
       "      <td>1111027381021</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>229</td>\n",
       "      <td>100</td>\n",
       "      <td>515.0</td>\n",
       "      <td>49306</td>\n",
       "      <td>104.45</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 24</td>\n",
       "      <td>2001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101685048....</td>\n",
       "      <td>101101685048</td>\n",
       "      <td>1111052857099</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>208</td>\n",
       "      <td>38</td>\n",
       "      <td>305.0</td>\n",
       "      <td>34731</td>\n",
       "      <td>87.82</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>高 14</td>\n",
       "      <td>2012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101704540....</td>\n",
       "      <td>101101704540</td>\n",
       "      <td>1111027378400</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>201</td>\n",
       "      <td>2</td>\n",
       "      <td>260.0</td>\n",
       "      <td>47247</td>\n",
       "      <td>55.03</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 6</td>\n",
       "      <td>1986</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102446043....</td>\n",
       "      <td>101102446043</td>\n",
       "      <td>1111027378900</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>509.0</td>\n",
       "      <td>121191</td>\n",
       "      <td>42.00</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>顶 6</td>\n",
       "      <td>1985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102446345....</td>\n",
       "      <td>101102446345</td>\n",
       "      <td>1111052073923</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>37495</td>\n",
       "      <td>46.14</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>顶 6</td>\n",
       "      <td>1990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102447671....</td>\n",
       "      <td>101102447671</td>\n",
       "      <td>1111027380943</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>1120.0</td>\n",
       "      <td>102970</td>\n",
       "      <td>108.77</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>中 6</td>\n",
       "      <td>2005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102451242....</td>\n",
       "      <td>101102451242</td>\n",
       "      <td>1111027381533</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>607.0</td>\n",
       "      <td>80729</td>\n",
       "      <td>75.19</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 22</td>\n",
       "      <td>2003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102452309....</td>\n",
       "      <td>101102452309</td>\n",
       "      <td>1111027380051</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>372.0</td>\n",
       "      <td>41822</td>\n",
       "      <td>88.95</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>高 6</td>\n",
       "      <td>2001</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>97 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 链家网址            id  \\\n",
       "0   https://bj.lianjia.com/chengjiao/101101492812....  101101492812   \n",
       "1   https://bj.lianjia.com/chengjiao/101101594408....  101101594408   \n",
       "2   https://bj.lianjia.com/chengjiao/101101601669....  101101601669   \n",
       "3   https://bj.lianjia.com/chengjiao/101101685048....  101101685048   \n",
       "4   https://bj.lianjia.com/chengjiao/101101704540....  101101704540   \n",
       "..                                                ...           ...   \n",
       "92  https://bj.lianjia.com/chengjiao/101102446043....  101102446043   \n",
       "93  https://bj.lianjia.com/chengjiao/101102446345....  101102446345   \n",
       "94  https://bj.lianjia.com/chengjiao/101102447671....  101102447671   \n",
       "95  https://bj.lianjia.com/chengjiao/101102451242....  101102451242   \n",
       "96  https://bj.lianjia.com/chengjiao/101102452309....  101102452309   \n",
       "\n",
       "           所在社区编号       交易时间  挂牌天数  关注人数      总价    平米均价      面积  卧室  客厅  厨房  \\\n",
       "0   1111027377718 2018-01-03   259   226   380.0   47560   79.90   2   1   1   \n",
       "1   1111027379032 2018-01-03   231     9   507.0   36071  140.56   3   2   1   \n",
       "2   1111027381021 2018-01-03   229   100   515.0   49306  104.45   3   1   1   \n",
       "3   1111052857099 2018-01-03   208    38   305.0   34731   87.82   2   1   1   \n",
       "4   1111027378400 2018-01-03   201     2   260.0   47247   55.03   2   1   1   \n",
       "..            ...        ...   ...   ...     ...     ...     ...  ..  ..  ..   \n",
       "92  1111027378900 2018-01-03     4     0   509.0  121191   42.00   1   1   1   \n",
       "93  1111052073923 2018-01-03     4     0   173.0   37495   46.14   1   1   1   \n",
       "94  1111027380943 2018-01-03     4     0  1120.0  102970  108.77   3   1   1   \n",
       "95  1111027381533 2018-01-03     2     0   607.0   80729   75.19   2   1   1   \n",
       "96  1111027380051 2018-01-03     2     0   372.0   41822   88.95   2   1   1   \n",
       "\n",
       "    浴室  楼层信息  建成时间  \n",
       "0    1   中 6  2004  \n",
       "1    2   中 6  2009  \n",
       "2    1  中 24  2001  \n",
       "3    1  高 14  2012  \n",
       "4    1   中 6  1986  \n",
       "..  ..   ...   ...  \n",
       "92   1   顶 6  1985  \n",
       "93   1   顶 6  1990  \n",
       "94   2   中 6  2005  \n",
       "95   1  中 22  2003  \n",
       "96   1   高 6  2001  \n",
       "\n",
       "[97 rows x 15 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "positive-circulation",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_excel(r'D:\\Programming\\Python\\PlayTogether_Data\\book3_pandas\\class12_readExcel\\house.xlsx', sheet_name='社区编号目录')\n",
    "# sheet_name = 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "included-cyprus",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>社区编号</th>\n",
       "      <th>社区名称</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1111027377718</td>\n",
       "      <td>龙博苑二区</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1111027379032</td>\n",
       "      <td>融科香雪兰溪</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1111027381021</td>\n",
       "      <td>兴隆家园</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1111052857099</td>\n",
       "      <td>绿地新都会</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1111027378400</td>\n",
       "      <td>模式口南里</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1111027378900</td>\n",
       "      <td>汽南小区</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1111052073923</td>\n",
       "      <td>门头沟月季园</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1111027380943</td>\n",
       "      <td>新街口西里一区</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1111027381533</td>\n",
       "      <td>逸成东苑</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1111027380051</td>\n",
       "      <td>天通苑东一区</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>90 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Unnamed: 0           社区编号     社区名称\n",
       "0          NaN  1111027377718    龙博苑二区\n",
       "1          NaN  1111027379032   融科香雪兰溪\n",
       "2          NaN  1111027381021     兴隆家园\n",
       "3          NaN  1111052857099    绿地新都会\n",
       "4          NaN  1111027378400    模式口南里\n",
       "..         ...            ...      ...\n",
       "85         NaN  1111027378900     汽南小区\n",
       "86         NaN  1111052073923   门头沟月季园\n",
       "87         NaN  1111027380943  新街口西里一区\n",
       "88         NaN  1111027381533     逸成东苑\n",
       "89         NaN  1111027380051   天通苑东一区\n",
       "\n",
       "[90 rows x 3 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "accepted-merit",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_excel(r'D:\\Programming\\Python\\PlayTogether_Data\\book3_pandas\\class12_readExcel\\house.xlsx', sheet_name=[0,1])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "molecular-headquarters",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{0:                                                  链家网址            id  \\\n",
       " 0   https://bj.lianjia.com/chengjiao/101101492812....  101101492812   \n",
       " 1   https://bj.lianjia.com/chengjiao/101101594408....  101101594408   \n",
       " 2   https://bj.lianjia.com/chengjiao/101101601669....  101101601669   \n",
       " 3   https://bj.lianjia.com/chengjiao/101101685048....  101101685048   \n",
       " 4   https://bj.lianjia.com/chengjiao/101101704540....  101101704540   \n",
       " ..                                                ...           ...   \n",
       " 92  https://bj.lianjia.com/chengjiao/101102446043....  101102446043   \n",
       " 93  https://bj.lianjia.com/chengjiao/101102446345....  101102446345   \n",
       " 94  https://bj.lianjia.com/chengjiao/101102447671....  101102447671   \n",
       " 95  https://bj.lianjia.com/chengjiao/101102451242....  101102451242   \n",
       " 96  https://bj.lianjia.com/chengjiao/101102452309....  101102452309   \n",
       " \n",
       "            所在社区编号       交易时间  挂牌天数  关注人数      总价    平米均价      面积  卧室  客厅  厨房  \\\n",
       " 0   1111027377718 2018-01-03   259   226   380.0   47560   79.90   2   1   1   \n",
       " 1   1111027379032 2018-01-03   231     9   507.0   36071  140.56   3   2   1   \n",
       " 2   1111027381021 2018-01-03   229   100   515.0   49306  104.45   3   1   1   \n",
       " 3   1111052857099 2018-01-03   208    38   305.0   34731   87.82   2   1   1   \n",
       " 4   1111027378400 2018-01-03   201     2   260.0   47247   55.03   2   1   1   \n",
       " ..            ...        ...   ...   ...     ...     ...     ...  ..  ..  ..   \n",
       " 92  1111027378900 2018-01-03     4     0   509.0  121191   42.00   1   1   1   \n",
       " 93  1111052073923 2018-01-03     4     0   173.0   37495   46.14   1   1   1   \n",
       " 94  1111027380943 2018-01-03     4     0  1120.0  102970  108.77   3   1   1   \n",
       " 95  1111027381533 2018-01-03     2     0   607.0   80729   75.19   2   1   1   \n",
       " 96  1111027380051 2018-01-03     2     0   372.0   41822   88.95   2   1   1   \n",
       " \n",
       "     浴室  楼层信息  建成时间  \n",
       " 0    1   中 6  2004  \n",
       " 1    2   中 6  2009  \n",
       " 2    1  中 24  2001  \n",
       " 3    1  高 14  2012  \n",
       " 4    1   中 6  1986  \n",
       " ..  ..   ...   ...  \n",
       " 92   1   顶 6  1985  \n",
       " 93   1   顶 6  1990  \n",
       " 94   2   中 6  2005  \n",
       " 95   1  中 22  2003  \n",
       " 96   1   高 6  2001  \n",
       " \n",
       " [97 rows x 15 columns],\n",
       " 1:     Unnamed: 0           社区编号     社区名称\n",
       " 0          NaN  1111027377718    龙博苑二区\n",
       " 1          NaN  1111027379032   融科香雪兰溪\n",
       " 2          NaN  1111027381021     兴隆家园\n",
       " 3          NaN  1111052857099    绿地新都会\n",
       " 4          NaN  1111027378400    模式口南里\n",
       " ..         ...            ...      ...\n",
       " 85         NaN  1111027378900     汽南小区\n",
       " 86         NaN  1111052073923   门头沟月季园\n",
       " 87         NaN  1111027380943  新街口西里一区\n",
       " 88         NaN  1111027381533     逸成东苑\n",
       " 89         NaN  1111027380051   天通苑东一区\n",
       " \n",
       " [90 rows x 3 columns]}"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "interior-winning",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>社区编号</th>\n",
       "      <th>社区名称</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1111027377718</td>\n",
       "      <td>龙博苑二区</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1111027379032</td>\n",
       "      <td>融科香雪兰溪</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1111027381021</td>\n",
       "      <td>兴隆家园</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1111052857099</td>\n",
       "      <td>绿地新都会</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1111027378400</td>\n",
       "      <td>模式口南里</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1111027378900</td>\n",
       "      <td>汽南小区</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1111052073923</td>\n",
       "      <td>门头沟月季园</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1111027380943</td>\n",
       "      <td>新街口西里一区</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1111027381533</td>\n",
       "      <td>逸成东苑</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1111027380051</td>\n",
       "      <td>天通苑东一区</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>90 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Unnamed: 0           社区编号     社区名称\n",
       "0          NaN  1111027377718    龙博苑二区\n",
       "1          NaN  1111027379032   融科香雪兰溪\n",
       "2          NaN  1111027381021     兴隆家园\n",
       "3          NaN  1111052857099    绿地新都会\n",
       "4          NaN  1111027378400    模式口南里\n",
       "..         ...            ...      ...\n",
       "85         NaN  1111027378900     汽南小区\n",
       "86         NaN  1111052073923   门头沟月季园\n",
       "87         NaN  1111027380943  新街口西里一区\n",
       "88         NaN  1111027381533     逸成东苑\n",
       "89         NaN  1111027380051   天通苑东一区\n",
       "\n",
       "[90 rows x 3 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "center-vitamin",
   "metadata": {},
   "outputs": [],
   "source": [
    "df03 = pd.read_excel(r'D:\\Programming\\Python\\PlayTogether_Data\\book3_pandas\\class12_readExcel\\house.xlsx', sheet_name='房屋成交信息 (2)', \n",
    "                     header=2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "polished-tattoo",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>链家网址</th>\n",
       "      <th>id</th>\n",
       "      <th>所在社区编号</th>\n",
       "      <th>交易时间</th>\n",
       "      <th>挂牌天数</th>\n",
       "      <th>关注人数</th>\n",
       "      <th>总价</th>\n",
       "      <th>平米均价</th>\n",
       "      <th>面积</th>\n",
       "      <th>卧室</th>\n",
       "      <th>客厅</th>\n",
       "      <th>厨房</th>\n",
       "      <th>浴室</th>\n",
       "      <th>楼层信息</th>\n",
       "      <th>建成时间</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101492812....</td>\n",
       "      <td>101101492812</td>\n",
       "      <td>1111027377718</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>259</td>\n",
       "      <td>226</td>\n",
       "      <td>380.0</td>\n",
       "      <td>47560</td>\n",
       "      <td>79.90</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 6</td>\n",
       "      <td>2004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101594408....</td>\n",
       "      <td>101101594408</td>\n",
       "      <td>1111027379032</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>231</td>\n",
       "      <td>9</td>\n",
       "      <td>507.0</td>\n",
       "      <td>36071</td>\n",
       "      <td>140.56</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>中 6</td>\n",
       "      <td>2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101601669....</td>\n",
       "      <td>101101601669</td>\n",
       "      <td>1111027381021</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>229</td>\n",
       "      <td>100</td>\n",
       "      <td>515.0</td>\n",
       "      <td>49306</td>\n",
       "      <td>104.45</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 24</td>\n",
       "      <td>2001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101685048....</td>\n",
       "      <td>101101685048</td>\n",
       "      <td>1111052857099</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>208</td>\n",
       "      <td>38</td>\n",
       "      <td>305.0</td>\n",
       "      <td>34731</td>\n",
       "      <td>87.82</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>高 14</td>\n",
       "      <td>2012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101704540....</td>\n",
       "      <td>101101704540</td>\n",
       "      <td>1111027378400</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>201</td>\n",
       "      <td>2</td>\n",
       "      <td>260.0</td>\n",
       "      <td>47247</td>\n",
       "      <td>55.03</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 6</td>\n",
       "      <td>1986</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102446043....</td>\n",
       "      <td>101102446043</td>\n",
       "      <td>1111027378900</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>509.0</td>\n",
       "      <td>121191</td>\n",
       "      <td>42.00</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>顶 6</td>\n",
       "      <td>1985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102446345....</td>\n",
       "      <td>101102446345</td>\n",
       "      <td>1111052073923</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>37495</td>\n",
       "      <td>46.14</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>顶 6</td>\n",
       "      <td>1990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102447671....</td>\n",
       "      <td>101102447671</td>\n",
       "      <td>1111027380943</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>1120.0</td>\n",
       "      <td>102970</td>\n",
       "      <td>108.77</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>中 6</td>\n",
       "      <td>2005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102451242....</td>\n",
       "      <td>101102451242</td>\n",
       "      <td>1111027381533</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>607.0</td>\n",
       "      <td>80729</td>\n",
       "      <td>75.19</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 22</td>\n",
       "      <td>2003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102452309....</td>\n",
       "      <td>101102452309</td>\n",
       "      <td>1111027380051</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>372.0</td>\n",
       "      <td>41822</td>\n",
       "      <td>88.95</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>高 6</td>\n",
       "      <td>2001</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>97 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 链家网址            id  \\\n",
       "0   https://bj.lianjia.com/chengjiao/101101492812....  101101492812   \n",
       "1   https://bj.lianjia.com/chengjiao/101101594408....  101101594408   \n",
       "2   https://bj.lianjia.com/chengjiao/101101601669....  101101601669   \n",
       "3   https://bj.lianjia.com/chengjiao/101101685048....  101101685048   \n",
       "4   https://bj.lianjia.com/chengjiao/101101704540....  101101704540   \n",
       "..                                                ...           ...   \n",
       "92  https://bj.lianjia.com/chengjiao/101102446043....  101102446043   \n",
       "93  https://bj.lianjia.com/chengjiao/101102446345....  101102446345   \n",
       "94  https://bj.lianjia.com/chengjiao/101102447671....  101102447671   \n",
       "95  https://bj.lianjia.com/chengjiao/101102451242....  101102451242   \n",
       "96  https://bj.lianjia.com/chengjiao/101102452309....  101102452309   \n",
       "\n",
       "           所在社区编号       交易时间  挂牌天数  关注人数      总价    平米均价      面积  卧室  客厅  厨房  \\\n",
       "0   1111027377718 2018-01-03   259   226   380.0   47560   79.90   2   1   1   \n",
       "1   1111027379032 2018-01-03   231     9   507.0   36071  140.56   3   2   1   \n",
       "2   1111027381021 2018-01-03   229   100   515.0   49306  104.45   3   1   1   \n",
       "3   1111052857099 2018-01-03   208    38   305.0   34731   87.82   2   1   1   \n",
       "4   1111027378400 2018-01-03   201     2   260.0   47247   55.03   2   1   1   \n",
       "..            ...        ...   ...   ...     ...     ...     ...  ..  ..  ..   \n",
       "92  1111027378900 2018-01-03     4     0   509.0  121191   42.00   1   1   1   \n",
       "93  1111052073923 2018-01-03     4     0   173.0   37495   46.14   1   1   1   \n",
       "94  1111027380943 2018-01-03     4     0  1120.0  102970  108.77   3   1   1   \n",
       "95  1111027381533 2018-01-03     2     0   607.0   80729   75.19   2   1   1   \n",
       "96  1111027380051 2018-01-03     2     0   372.0   41822   88.95   2   1   1   \n",
       "\n",
       "    浴室  楼层信息  建成时间  \n",
       "0    1   中 6  2004  \n",
       "1    2   中 6  2009  \n",
       "2    1  中 24  2001  \n",
       "3    1  高 14  2012  \n",
       "4    1   中 6  1986  \n",
       "..  ..   ...   ...  \n",
       "92   1   顶 6  1985  \n",
       "93   1   顶 6  1990  \n",
       "94   2   中 6  2005  \n",
       "95   1  中 22  2003  \n",
       "96   1   高 6  2001  \n",
       "\n",
       "[97 rows x 15 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df03"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "polyphonic-explorer",
   "metadata": {},
   "outputs": [],
   "source": [
    "df04 = pd.read_excel(r'D:\\Programming\\Python\\PlayTogether_Data\\book3_pandas\\class12_readExcel\\house.xlsx', sheet_name='房屋成交信息 (2)', \n",
    "                     header=[2, 3, 4])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "altered-murder",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>链家网址</th>\n",
       "      <th>id</th>\n",
       "      <th>所在社区编号</th>\n",
       "      <th>交易时间</th>\n",
       "      <th>挂牌天数</th>\n",
       "      <th>关注人数</th>\n",
       "      <th>总价</th>\n",
       "      <th>平米均价</th>\n",
       "      <th>面积</th>\n",
       "      <th>卧室</th>\n",
       "      <th>客厅</th>\n",
       "      <th>厨房</th>\n",
       "      <th>浴室</th>\n",
       "      <th>楼层信息</th>\n",
       "      <th>建成时间</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>https://bj.lianjia.com/chengjiao/101101492812.html</th>\n",
       "      <th>101101492812</th>\n",
       "      <th>1111027377718</th>\n",
       "      <th>2018-01-03 00:00:00</th>\n",
       "      <th>259</th>\n",
       "      <th>226</th>\n",
       "      <th>380</th>\n",
       "      <th>47560</th>\n",
       "      <th>79.9</th>\n",
       "      <th>2</th>\n",
       "      <th>1</th>\n",
       "      <th>1</th>\n",
       "      <th>1</th>\n",
       "      <th>中 6</th>\n",
       "      <th>2004</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>https://bj.lianjia.com/chengjiao/101101594408.html</th>\n",
       "      <th>101101594408</th>\n",
       "      <th>1111027379032</th>\n",
       "      <th>2018-01-03 00:00:00</th>\n",
       "      <th>231</th>\n",
       "      <th>9</th>\n",
       "      <th>507</th>\n",
       "      <th>36071</th>\n",
       "      <th>140.56</th>\n",
       "      <th>3</th>\n",
       "      <th>2</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>中 6</th>\n",
       "      <th>2009</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101601669....</td>\n",
       "      <td>101101601669</td>\n",
       "      <td>1111027381021</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>229</td>\n",
       "      <td>100</td>\n",
       "      <td>515.0</td>\n",
       "      <td>49306</td>\n",
       "      <td>104.45</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 24</td>\n",
       "      <td>2001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101685048....</td>\n",
       "      <td>101101685048</td>\n",
       "      <td>1111052857099</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>208</td>\n",
       "      <td>38</td>\n",
       "      <td>305.0</td>\n",
       "      <td>34731</td>\n",
       "      <td>87.82</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>高 14</td>\n",
       "      <td>2012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101704540....</td>\n",
       "      <td>101101704540</td>\n",
       "      <td>1111027378400</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>201</td>\n",
       "      <td>2</td>\n",
       "      <td>260.0</td>\n",
       "      <td>47247</td>\n",
       "      <td>55.03</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 6</td>\n",
       "      <td>1986</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101711072....</td>\n",
       "      <td>101101711072</td>\n",
       "      <td>1111027375945</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>200</td>\n",
       "      <td>313</td>\n",
       "      <td>665.0</td>\n",
       "      <td>49013</td>\n",
       "      <td>135.68</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>中 28</td>\n",
       "      <td>2008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101739667....</td>\n",
       "      <td>101101739667</td>\n",
       "      <td>1111041160125</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>192</td>\n",
       "      <td>125</td>\n",
       "      <td>316.0</td>\n",
       "      <td>40446</td>\n",
       "      <td>78.13</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>顶 22</td>\n",
       "      <td>2008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102446043....</td>\n",
       "      <td>101102446043</td>\n",
       "      <td>1111027378900</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>509.0</td>\n",
       "      <td>121191</td>\n",
       "      <td>42.00</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>顶 6</td>\n",
       "      <td>1985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102446345....</td>\n",
       "      <td>101102446345</td>\n",
       "      <td>1111052073923</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>37495</td>\n",
       "      <td>46.14</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>顶 6</td>\n",
       "      <td>1990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102447671....</td>\n",
       "      <td>101102447671</td>\n",
       "      <td>1111027380943</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>1120.0</td>\n",
       "      <td>102970</td>\n",
       "      <td>108.77</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>中 6</td>\n",
       "      <td>2005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102451242....</td>\n",
       "      <td>101102451242</td>\n",
       "      <td>1111027381533</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>607.0</td>\n",
       "      <td>80729</td>\n",
       "      <td>75.19</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 22</td>\n",
       "      <td>2003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102452309....</td>\n",
       "      <td>101102452309</td>\n",
       "      <td>1111027380051</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>372.0</td>\n",
       "      <td>41822</td>\n",
       "      <td>88.95</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>高 6</td>\n",
       "      <td>2001</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>95 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 链家网址            id  \\\n",
       "   https://bj.lianjia.com/chengjiao/101101492812.html  101101492812   \n",
       "   https://bj.lianjia.com/chengjiao/101101594408.html  101101594408   \n",
       "0   https://bj.lianjia.com/chengjiao/101101601669....  101101601669   \n",
       "1   https://bj.lianjia.com/chengjiao/101101685048....  101101685048   \n",
       "2   https://bj.lianjia.com/chengjiao/101101704540....  101101704540   \n",
       "3   https://bj.lianjia.com/chengjiao/101101711072....  101101711072   \n",
       "4   https://bj.lianjia.com/chengjiao/101101739667....  101101739667   \n",
       "..                                                ...           ...   \n",
       "90  https://bj.lianjia.com/chengjiao/101102446043....  101102446043   \n",
       "91  https://bj.lianjia.com/chengjiao/101102446345....  101102446345   \n",
       "92  https://bj.lianjia.com/chengjiao/101102447671....  101102447671   \n",
       "93  https://bj.lianjia.com/chengjiao/101102451242....  101102451242   \n",
       "94  https://bj.lianjia.com/chengjiao/101102452309....  101102452309   \n",
       "\n",
       "           所在社区编号                交易时间 挂牌天数 关注人数      总价    平米均价      面积 卧室 客厅  \\\n",
       "    1111027377718 2018-01-03 00:00:00  259  226     380   47560    79.9  2  1   \n",
       "    1111027379032 2018-01-03 00:00:00  231    9     507   36071  140.56  3  2   \n",
       "0   1111027381021          2018-01-03  229  100   515.0   49306  104.45  3  1   \n",
       "1   1111052857099          2018-01-03  208   38   305.0   34731   87.82  2  1   \n",
       "2   1111027378400          2018-01-03  201    2   260.0   47247   55.03  2  1   \n",
       "3   1111027375945          2018-01-03  200  313   665.0   49013  135.68  3  1   \n",
       "4   1111041160125          2018-01-03  192  125   316.0   40446   78.13  2  1   \n",
       "..            ...                 ...  ...  ...     ...     ...     ... .. ..   \n",
       "90  1111027378900          2018-01-03    4    0   509.0  121191   42.00  1  1   \n",
       "91  1111052073923          2018-01-03    4    0   173.0   37495   46.14  1  1   \n",
       "92  1111027380943          2018-01-03    4    0  1120.0  102970  108.77  3  1   \n",
       "93  1111027381533          2018-01-03    2    0   607.0   80729   75.19  2  1   \n",
       "94  1111027380051          2018-01-03    2    0   372.0   41822   88.95  2  1   \n",
       "\n",
       "   厨房 浴室  楼层信息  建成时间  \n",
       "    1  1   中 6  2004  \n",
       "    1  2   中 6  2009  \n",
       "0   1  1  中 24  2001  \n",
       "1   1  1  高 14  2012  \n",
       "2   1  1   中 6  1986  \n",
       "3   1  2  中 28  2008  \n",
       "4   1  1  顶 22  2008  \n",
       ".. .. ..   ...   ...  \n",
       "90  1  1   顶 6  1985  \n",
       "91  1  1   顶 6  1990  \n",
       "92  1  2   中 6  2005  \n",
       "93  1  1  中 22  2003  \n",
       "94  1  1   高 6  2001  \n",
       "\n",
       "[95 rows x 15 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df04"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "attempted-virginia",
   "metadata": {},
   "outputs": [],
   "source": [
    "df05 = pd.read_excel(r'D:\\Programming\\Python\\PlayTogether_Data\\book3_pandas\\class12_readExcel\\house.xlsx', sheet_name='房屋成交信息 (3)', \n",
    "                     header=None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "consolidated-dodge",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>10</th>\n",
       "      <th>11</th>\n",
       "      <th>12</th>\n",
       "      <th>13</th>\n",
       "      <th>14</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101492812....</td>\n",
       "      <td>101101492812</td>\n",
       "      <td>1111027377718</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>259</td>\n",
       "      <td>226</td>\n",
       "      <td>380.0</td>\n",
       "      <td>47560</td>\n",
       "      <td>79.90</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 6</td>\n",
       "      <td>2004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101594408....</td>\n",
       "      <td>101101594408</td>\n",
       "      <td>1111027379032</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>231</td>\n",
       "      <td>9</td>\n",
       "      <td>507.0</td>\n",
       "      <td>36071</td>\n",
       "      <td>140.56</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>中 6</td>\n",
       "      <td>2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101601669....</td>\n",
       "      <td>101101601669</td>\n",
       "      <td>1111027381021</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>229</td>\n",
       "      <td>100</td>\n",
       "      <td>515.0</td>\n",
       "      <td>49306</td>\n",
       "      <td>104.45</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 24</td>\n",
       "      <td>2001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101685048....</td>\n",
       "      <td>101101685048</td>\n",
       "      <td>1111052857099</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>208</td>\n",
       "      <td>38</td>\n",
       "      <td>305.0</td>\n",
       "      <td>34731</td>\n",
       "      <td>87.82</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>高 14</td>\n",
       "      <td>2012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101704540....</td>\n",
       "      <td>101101704540</td>\n",
       "      <td>1111027378400</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>201</td>\n",
       "      <td>2</td>\n",
       "      <td>260.0</td>\n",
       "      <td>47247</td>\n",
       "      <td>55.03</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 6</td>\n",
       "      <td>1986</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102446043....</td>\n",
       "      <td>101102446043</td>\n",
       "      <td>1111027378900</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>509.0</td>\n",
       "      <td>121191</td>\n",
       "      <td>42.00</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>顶 6</td>\n",
       "      <td>1985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102446345....</td>\n",
       "      <td>101102446345</td>\n",
       "      <td>1111052073923</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>37495</td>\n",
       "      <td>46.14</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>顶 6</td>\n",
       "      <td>1990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102447671....</td>\n",
       "      <td>101102447671</td>\n",
       "      <td>1111027380943</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>1120.0</td>\n",
       "      <td>102970</td>\n",
       "      <td>108.77</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>中 6</td>\n",
       "      <td>2005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102451242....</td>\n",
       "      <td>101102451242</td>\n",
       "      <td>1111027381533</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>607.0</td>\n",
       "      <td>80729</td>\n",
       "      <td>75.19</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 22</td>\n",
       "      <td>2003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102452309....</td>\n",
       "      <td>101102452309</td>\n",
       "      <td>1111027380051</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>372.0</td>\n",
       "      <td>41822</td>\n",
       "      <td>88.95</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>高 6</td>\n",
       "      <td>2001</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>97 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   0             1   \\\n",
       "0   https://bj.lianjia.com/chengjiao/101101492812....  101101492812   \n",
       "1   https://bj.lianjia.com/chengjiao/101101594408....  101101594408   \n",
       "2   https://bj.lianjia.com/chengjiao/101101601669....  101101601669   \n",
       "3   https://bj.lianjia.com/chengjiao/101101685048....  101101685048   \n",
       "4   https://bj.lianjia.com/chengjiao/101101704540....  101101704540   \n",
       "..                                                ...           ...   \n",
       "92  https://bj.lianjia.com/chengjiao/101102446043....  101102446043   \n",
       "93  https://bj.lianjia.com/chengjiao/101102446345....  101102446345   \n",
       "94  https://bj.lianjia.com/chengjiao/101102447671....  101102447671   \n",
       "95  https://bj.lianjia.com/chengjiao/101102451242....  101102451242   \n",
       "96  https://bj.lianjia.com/chengjiao/101102452309....  101102452309   \n",
       "\n",
       "               2          3    4    5       6       7       8   9   10  11  \\\n",
       "0   1111027377718 2018-01-03  259  226   380.0   47560   79.90   2   1   1   \n",
       "1   1111027379032 2018-01-03  231    9   507.0   36071  140.56   3   2   1   \n",
       "2   1111027381021 2018-01-03  229  100   515.0   49306  104.45   3   1   1   \n",
       "3   1111052857099 2018-01-03  208   38   305.0   34731   87.82   2   1   1   \n",
       "4   1111027378400 2018-01-03  201    2   260.0   47247   55.03   2   1   1   \n",
       "..            ...        ...  ...  ...     ...     ...     ...  ..  ..  ..   \n",
       "92  1111027378900 2018-01-03    4    0   509.0  121191   42.00   1   1   1   \n",
       "93  1111052073923 2018-01-03    4    0   173.0   37495   46.14   1   1   1   \n",
       "94  1111027380943 2018-01-03    4    0  1120.0  102970  108.77   3   1   1   \n",
       "95  1111027381533 2018-01-03    2    0   607.0   80729   75.19   2   1   1   \n",
       "96  1111027380051 2018-01-03    2    0   372.0   41822   88.95   2   1   1   \n",
       "\n",
       "    12    13    14  \n",
       "0    1   中 6  2004  \n",
       "1    2   中 6  2009  \n",
       "2    1  中 24  2001  \n",
       "3    1  高 14  2012  \n",
       "4    1   中 6  1986  \n",
       "..  ..   ...   ...  \n",
       "92   1   顶 6  1985  \n",
       "93   1   顶 6  1990  \n",
       "94   2   中 6  2005  \n",
       "95   1  中 22  2003  \n",
       "96   1   高 6  2001  \n",
       "\n",
       "[97 rows x 15 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df05"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "heard-split",
   "metadata": {},
   "outputs": [],
   "source": [
    "df05 = pd.read_excel(r'D:\\Programming\\Python\\PlayTogether_Data\\book3_pandas\\class12_readExcel\\house.xlsx', sheet_name='房屋成交信息 (3)', \n",
    "                     header=None, names=['Website', 'ID', 'SN', '交易时间', '挂牌天数', '关注人数', '总价', '平米均价', '面积', '卧室', '客厅', \n",
    "                                        '厨房', '浴室', '楼层信息', '建成时间'])\n",
    "# 自右向左填充"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "focal-garlic",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Website</th>\n",
       "      <th>ID</th>\n",
       "      <th>SN</th>\n",
       "      <th>交易时间</th>\n",
       "      <th>挂牌天数</th>\n",
       "      <th>关注人数</th>\n",
       "      <th>总价</th>\n",
       "      <th>平米均价</th>\n",
       "      <th>面积</th>\n",
       "      <th>卧室</th>\n",
       "      <th>客厅</th>\n",
       "      <th>厨房</th>\n",
       "      <th>浴室</th>\n",
       "      <th>楼层信息</th>\n",
       "      <th>建成时间</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101492812....</td>\n",
       "      <td>101101492812</td>\n",
       "      <td>1111027377718</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>259</td>\n",
       "      <td>226</td>\n",
       "      <td>380.0</td>\n",
       "      <td>47560</td>\n",
       "      <td>79.90</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 6</td>\n",
       "      <td>2004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101594408....</td>\n",
       "      <td>101101594408</td>\n",
       "      <td>1111027379032</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>231</td>\n",
       "      <td>9</td>\n",
       "      <td>507.0</td>\n",
       "      <td>36071</td>\n",
       "      <td>140.56</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>中 6</td>\n",
       "      <td>2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101601669....</td>\n",
       "      <td>101101601669</td>\n",
       "      <td>1111027381021</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>229</td>\n",
       "      <td>100</td>\n",
       "      <td>515.0</td>\n",
       "      <td>49306</td>\n",
       "      <td>104.45</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 24</td>\n",
       "      <td>2001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101685048....</td>\n",
       "      <td>101101685048</td>\n",
       "      <td>1111052857099</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>208</td>\n",
       "      <td>38</td>\n",
       "      <td>305.0</td>\n",
       "      <td>34731</td>\n",
       "      <td>87.82</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>高 14</td>\n",
       "      <td>2012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101704540....</td>\n",
       "      <td>101101704540</td>\n",
       "      <td>1111027378400</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>201</td>\n",
       "      <td>2</td>\n",
       "      <td>260.0</td>\n",
       "      <td>47247</td>\n",
       "      <td>55.03</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 6</td>\n",
       "      <td>1986</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102446043....</td>\n",
       "      <td>101102446043</td>\n",
       "      <td>1111027378900</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>509.0</td>\n",
       "      <td>121191</td>\n",
       "      <td>42.00</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>顶 6</td>\n",
       "      <td>1985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102446345....</td>\n",
       "      <td>101102446345</td>\n",
       "      <td>1111052073923</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>37495</td>\n",
       "      <td>46.14</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>顶 6</td>\n",
       "      <td>1990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102447671....</td>\n",
       "      <td>101102447671</td>\n",
       "      <td>1111027380943</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>1120.0</td>\n",
       "      <td>102970</td>\n",
       "      <td>108.77</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>中 6</td>\n",
       "      <td>2005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102451242....</td>\n",
       "      <td>101102451242</td>\n",
       "      <td>1111027381533</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>607.0</td>\n",
       "      <td>80729</td>\n",
       "      <td>75.19</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 22</td>\n",
       "      <td>2003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102452309....</td>\n",
       "      <td>101102452309</td>\n",
       "      <td>1111027380051</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>372.0</td>\n",
       "      <td>41822</td>\n",
       "      <td>88.95</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>高 6</td>\n",
       "      <td>2001</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>97 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              Website            ID  \\\n",
       "0   https://bj.lianjia.com/chengjiao/101101492812....  101101492812   \n",
       "1   https://bj.lianjia.com/chengjiao/101101594408....  101101594408   \n",
       "2   https://bj.lianjia.com/chengjiao/101101601669....  101101601669   \n",
       "3   https://bj.lianjia.com/chengjiao/101101685048....  101101685048   \n",
       "4   https://bj.lianjia.com/chengjiao/101101704540....  101101704540   \n",
       "..                                                ...           ...   \n",
       "92  https://bj.lianjia.com/chengjiao/101102446043....  101102446043   \n",
       "93  https://bj.lianjia.com/chengjiao/101102446345....  101102446345   \n",
       "94  https://bj.lianjia.com/chengjiao/101102447671....  101102447671   \n",
       "95  https://bj.lianjia.com/chengjiao/101102451242....  101102451242   \n",
       "96  https://bj.lianjia.com/chengjiao/101102452309....  101102452309   \n",
       "\n",
       "               SN       交易时间  挂牌天数  关注人数      总价    平米均价      面积  卧室  客厅  厨房  \\\n",
       "0   1111027377718 2018-01-03   259   226   380.0   47560   79.90   2   1   1   \n",
       "1   1111027379032 2018-01-03   231     9   507.0   36071  140.56   3   2   1   \n",
       "2   1111027381021 2018-01-03   229   100   515.0   49306  104.45   3   1   1   \n",
       "3   1111052857099 2018-01-03   208    38   305.0   34731   87.82   2   1   1   \n",
       "4   1111027378400 2018-01-03   201     2   260.0   47247   55.03   2   1   1   \n",
       "..            ...        ...   ...   ...     ...     ...     ...  ..  ..  ..   \n",
       "92  1111027378900 2018-01-03     4     0   509.0  121191   42.00   1   1   1   \n",
       "93  1111052073923 2018-01-03     4     0   173.0   37495   46.14   1   1   1   \n",
       "94  1111027380943 2018-01-03     4     0  1120.0  102970  108.77   3   1   1   \n",
       "95  1111027381533 2018-01-03     2     0   607.0   80729   75.19   2   1   1   \n",
       "96  1111027380051 2018-01-03     2     0   372.0   41822   88.95   2   1   1   \n",
       "\n",
       "    浴室  楼层信息  建成时间  \n",
       "0    1   中 6  2004  \n",
       "1    2   中 6  2009  \n",
       "2    1  中 24  2001  \n",
       "3    1  高 14  2012  \n",
       "4    1   中 6  1986  \n",
       "..  ..   ...   ...  \n",
       "92   1   顶 6  1985  \n",
       "93   1   顶 6  1990  \n",
       "94   2   中 6  2005  \n",
       "95   1  中 22  2003  \n",
       "96   1   高 6  2001  \n",
       "\n",
       "[97 rows x 15 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df05"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "micro-briefs",
   "metadata": {},
   "outputs": [],
   "source": [
    "df06 = pd.read_excel(r'D:\\Programming\\Python\\PlayTogether_Data\\book3_pandas\\class12_readExcel\\house.xlsx', sheet_name='房屋成交信息 (4)',\n",
    "                     usecols=[3, 5, 10, 11, 12, 13, 14], index_col='ID')\n",
    "# [3, 5, 10, 11, 12, 13, 14]\n",
    "# 建议字符串 + 字母表述，可以使用“:”连续选择列\n",
    "# 'D, F, L:O'\n",
    "\n",
    "# index_col = 0，替代自动序号"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "sporting-motel",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>交易时间</th>\n",
       "      <th>面积</th>\n",
       "      <th>卧室</th>\n",
       "      <th>客厅</th>\n",
       "      <th>厨房</th>\n",
       "      <th>浴室</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>101101492812</th>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>79.90</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101101594408</th>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>140.56</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101101601669</th>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>104.45</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101101685048</th>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>87.82</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101101704540</th>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>55.03</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101102446043</th>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>42.00</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101102446345</th>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>46.14</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101102447671</th>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>108.77</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101102451242</th>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>75.19</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101102452309</th>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>88.95</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>97 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   交易时间      面积  卧室  客厅  厨房  浴室\n",
       "ID                                             \n",
       "101101492812 2018-01-03   79.90   2   1   1   1\n",
       "101101594408 2018-01-03  140.56   3   2   1   2\n",
       "101101601669 2018-01-03  104.45   3   1   1   1\n",
       "101101685048 2018-01-03   87.82   2   1   1   1\n",
       "101101704540 2018-01-03   55.03   2   1   1   1\n",
       "...                 ...     ...  ..  ..  ..  ..\n",
       "101102446043 2018-01-03   42.00   1   1   1   1\n",
       "101102446345 2018-01-03   46.14   1   1   1   1\n",
       "101102447671 2018-01-03  108.77   3   1   1   2\n",
       "101102451242 2018-01-03   75.19   2   1   1   1\n",
       "101102452309 2018-01-03   88.95   2   1   1   1\n",
       "\n",
       "[97 rows x 6 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df06"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "ongoing-local",
   "metadata": {},
   "outputs": [],
   "source": [
    "# usecols跳列，skiprows跳行\n",
    "df07 = pd.read_excel(r'D:\\Programming\\Python\\PlayTogether_Data\\book3_pandas\\class12_readExcel\\house.xlsx', \n",
    "                     sheet_name='房屋成交信息', \n",
    "                     usecols = \"c:e\", \n",
    "                     skiprows=[0,3])\n",
    "\n",
    "# 跳过4行\n",
    "# skiprows=3\n",
    "# ----------\n",
    "# 跳过行0和3\n",
    "# skiprows=[0,3]\n",
    "# --------------"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "affected-midwest",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>1111027377718</th>\n",
       "      <th>2018-01-03 00:00:00</th>\n",
       "      <th>259</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1111027379032</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1111052857099</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1111027378400</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1111027375945</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1111041160125</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>192</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>1111027378900</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>1111052073923</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>1111027380943</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>1111027381533</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>1111027380051</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>95 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    1111027377718 2018-01-03 00:00:00  259\n",
       "0   1111027379032          2018-01-03  231\n",
       "1   1111052857099          2018-01-03  208\n",
       "2   1111027378400          2018-01-03  201\n",
       "3   1111027375945          2018-01-03  200\n",
       "4   1111041160125          2018-01-03  192\n",
       "..            ...                 ...  ...\n",
       "90  1111027378900          2018-01-03    4\n",
       "91  1111052073923          2018-01-03    4\n",
       "92  1111027380943          2018-01-03    4\n",
       "93  1111027381533          2018-01-03    2\n",
       "94  1111027380051          2018-01-03    2\n",
       "\n",
       "[95 rows x 3 columns]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df07"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "thick-conflict",
   "metadata": {},
   "outputs": [],
   "source": [
    "def is_Odd(x):\n",
    "    if x%2!=0:\n",
    "        return True\n",
    "    return False"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "pressed-heart",
   "metadata": {},
   "outputs": [],
   "source": [
    "df08 = pd.read_excel(r'D:\\Programming\\Python\\PlayTogether_Data\\book3_pandas\\class12_readExcel\\house.xlsx', sheet_name='房屋成交信息',\n",
    "                     skiprows=is_Odd)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "celtic-distinction",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>链家网址</th>\n",
       "      <th>id</th>\n",
       "      <th>所在社区编号</th>\n",
       "      <th>交易时间</th>\n",
       "      <th>挂牌天数</th>\n",
       "      <th>关注人数</th>\n",
       "      <th>总价</th>\n",
       "      <th>平米均价</th>\n",
       "      <th>面积</th>\n",
       "      <th>卧室</th>\n",
       "      <th>客厅</th>\n",
       "      <th>厨房</th>\n",
       "      <th>浴室</th>\n",
       "      <th>楼层信息</th>\n",
       "      <th>建成时间</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101594408....</td>\n",
       "      <td>101101594408</td>\n",
       "      <td>1111027379032</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>231</td>\n",
       "      <td>9</td>\n",
       "      <td>507.0</td>\n",
       "      <td>36071</td>\n",
       "      <td>140.56</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>中 6</td>\n",
       "      <td>2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101685048....</td>\n",
       "      <td>101101685048</td>\n",
       "      <td>1111052857099</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>208</td>\n",
       "      <td>38</td>\n",
       "      <td>305.0</td>\n",
       "      <td>34731</td>\n",
       "      <td>87.82</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>高 14</td>\n",
       "      <td>2012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101711072....</td>\n",
       "      <td>101101711072</td>\n",
       "      <td>1111027375945</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>200</td>\n",
       "      <td>313</td>\n",
       "      <td>665.0</td>\n",
       "      <td>49013</td>\n",
       "      <td>135.68</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>中 28</td>\n",
       "      <td>2008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101814992....</td>\n",
       "      <td>101101814992</td>\n",
       "      <td>1111027374762</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>173</td>\n",
       "      <td>82</td>\n",
       "      <td>1460.0</td>\n",
       "      <td>80896</td>\n",
       "      <td>180.48</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>中 32</td>\n",
       "      <td>2011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101843015....</td>\n",
       "      <td>101101843015</td>\n",
       "      <td>1111027378386</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>167</td>\n",
       "      <td>370</td>\n",
       "      <td>410.0</td>\n",
       "      <td>60065</td>\n",
       "      <td>68.26</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>顶 6</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101866373....</td>\n",
       "      <td>101101866373</td>\n",
       "      <td>1111027375613</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>160</td>\n",
       "      <td>111</td>\n",
       "      <td>1148.0</td>\n",
       "      <td>79767</td>\n",
       "      <td>143.92</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>中 11</td>\n",
       "      <td>2005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101101976063....</td>\n",
       "      <td>101101976063</td>\n",
       "      <td>1111027374693</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>136</td>\n",
       "      <td>176</td>\n",
       "      <td>168.0</td>\n",
       "      <td>31663</td>\n",
       "      <td>53.06</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 23</td>\n",
       "      <td>2008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102047604....</td>\n",
       "      <td>101102047604</td>\n",
       "      <td>1111027376959</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>119</td>\n",
       "      <td>144</td>\n",
       "      <td>610.0</td>\n",
       "      <td>115750</td>\n",
       "      <td>52.70</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>底 5</td>\n",
       "      <td>1981</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102073737....</td>\n",
       "      <td>101102073737</td>\n",
       "      <td>1111045368414</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>113</td>\n",
       "      <td>130</td>\n",
       "      <td>211.0</td>\n",
       "      <td>42739</td>\n",
       "      <td>49.37</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>高 15</td>\n",
       "      <td>2012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102087081....</td>\n",
       "      <td>101102087081</td>\n",
       "      <td>1111027377889</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>109</td>\n",
       "      <td>67</td>\n",
       "      <td>250.0</td>\n",
       "      <td>42453</td>\n",
       "      <td>58.89</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>低 6</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102111185....</td>\n",
       "      <td>101102111185</td>\n",
       "      <td>1111027382608</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>103</td>\n",
       "      <td>33</td>\n",
       "      <td>410.0</td>\n",
       "      <td>36795</td>\n",
       "      <td>111.43</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 11</td>\n",
       "      <td>2006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102158470....</td>\n",
       "      <td>101102158470</td>\n",
       "      <td>1111027381711</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>89</td>\n",
       "      <td>15</td>\n",
       "      <td>1655.0</td>\n",
       "      <td>89204</td>\n",
       "      <td>185.53</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>中 16</td>\n",
       "      <td>2001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102196240....</td>\n",
       "      <td>101102196240</td>\n",
       "      <td>1111027379032</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>80</td>\n",
       "      <td>71</td>\n",
       "      <td>330.0</td>\n",
       "      <td>36971</td>\n",
       "      <td>89.26</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 20</td>\n",
       "      <td>2010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102213253....</td>\n",
       "      <td>101102213253</td>\n",
       "      <td>1111027382064</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>75</td>\n",
       "      <td>132</td>\n",
       "      <td>510.0</td>\n",
       "      <td>90266</td>\n",
       "      <td>56.50</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 5</td>\n",
       "      <td>1973</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102220650....</td>\n",
       "      <td>101102220650</td>\n",
       "      <td>1111027382441</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>73</td>\n",
       "      <td>56</td>\n",
       "      <td>666.0</td>\n",
       "      <td>81899</td>\n",
       "      <td>81.32</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 24</td>\n",
       "      <td>2011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102231187....</td>\n",
       "      <td>101102231187</td>\n",
       "      <td>1111027381705</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>70</td>\n",
       "      <td>41</td>\n",
       "      <td>940.0</td>\n",
       "      <td>60622</td>\n",
       "      <td>155.06</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>中 29</td>\n",
       "      <td>2005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102234186....</td>\n",
       "      <td>101102234186</td>\n",
       "      <td>1111046997447</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>70</td>\n",
       "      <td>52</td>\n",
       "      <td>300.0</td>\n",
       "      <td>33857</td>\n",
       "      <td>88.61</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>低 16</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102244732....</td>\n",
       "      <td>101102244732</td>\n",
       "      <td>1111027378724</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>67</td>\n",
       "      <td>0</td>\n",
       "      <td>222.0</td>\n",
       "      <td>60000</td>\n",
       "      <td>37.00</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 15</td>\n",
       "      <td>1991</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102257575....</td>\n",
       "      <td>101102257575</td>\n",
       "      <td>1111027377467</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>64</td>\n",
       "      <td>89</td>\n",
       "      <td>400.0</td>\n",
       "      <td>53982</td>\n",
       "      <td>74.10</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>低 6</td>\n",
       "      <td>2004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102278923....</td>\n",
       "      <td>101102278923</td>\n",
       "      <td>1111027375273</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>58</td>\n",
       "      <td>21</td>\n",
       "      <td>479.0</td>\n",
       "      <td>56923</td>\n",
       "      <td>84.15</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>低 28</td>\n",
       "      <td>2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102296349....</td>\n",
       "      <td>101102296349</td>\n",
       "      <td>1111027380074</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>53</td>\n",
       "      <td>106</td>\n",
       "      <td>217.0</td>\n",
       "      <td>42516</td>\n",
       "      <td>51.04</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>高 6</td>\n",
       "      <td>1997</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102305206....</td>\n",
       "      <td>101102305206</td>\n",
       "      <td>1111027378131</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>50</td>\n",
       "      <td>254</td>\n",
       "      <td>330.0</td>\n",
       "      <td>52216</td>\n",
       "      <td>63.20</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 11</td>\n",
       "      <td>2011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102331601....</td>\n",
       "      <td>101102331601</td>\n",
       "      <td>1111027381745</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>41</td>\n",
       "      <td>61</td>\n",
       "      <td>440.0</td>\n",
       "      <td>37314</td>\n",
       "      <td>117.92</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>中 6</td>\n",
       "      <td>2002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102338279....</td>\n",
       "      <td>101102338279</td>\n",
       "      <td>1111027373686</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>39</td>\n",
       "      <td>24</td>\n",
       "      <td>595.0</td>\n",
       "      <td>80887</td>\n",
       "      <td>73.56</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 21</td>\n",
       "      <td>2006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102345112....</td>\n",
       "      <td>101102345112</td>\n",
       "      <td>1111027377297</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>37</td>\n",
       "      <td>40</td>\n",
       "      <td>396.0</td>\n",
       "      <td>51826</td>\n",
       "      <td>76.41</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 28</td>\n",
       "      <td>2008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102363365....</td>\n",
       "      <td>101102363365</td>\n",
       "      <td>1111027381444</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>32</td>\n",
       "      <td>38</td>\n",
       "      <td>222.5</td>\n",
       "      <td>40647</td>\n",
       "      <td>54.74</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 6</td>\n",
       "      <td>1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102373488....</td>\n",
       "      <td>101102373488</td>\n",
       "      <td>1111027381702</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>29</td>\n",
       "      <td>118</td>\n",
       "      <td>568.0</td>\n",
       "      <td>55917</td>\n",
       "      <td>101.58</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>低 29</td>\n",
       "      <td>2002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102383096....</td>\n",
       "      <td>101102383096</td>\n",
       "      <td>1111027381067</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>26</td>\n",
       "      <td>14</td>\n",
       "      <td>350.0</td>\n",
       "      <td>70708</td>\n",
       "      <td>49.50</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 6</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102383680....</td>\n",
       "      <td>101102383680</td>\n",
       "      <td>1111027378890</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>25</td>\n",
       "      <td>30</td>\n",
       "      <td>431.0</td>\n",
       "      <td>67672</td>\n",
       "      <td>63.69</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>低 16</td>\n",
       "      <td>2008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102391715....</td>\n",
       "      <td>101102391715</td>\n",
       "      <td>1111027381705</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>23</td>\n",
       "      <td>82</td>\n",
       "      <td>386.0</td>\n",
       "      <td>60626</td>\n",
       "      <td>63.67</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 6</td>\n",
       "      <td>1990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102395736....</td>\n",
       "      <td>101102395736</td>\n",
       "      <td>1111027381735</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>22</td>\n",
       "      <td>9</td>\n",
       "      <td>590.0</td>\n",
       "      <td>58163</td>\n",
       "      <td>101.44</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 16</td>\n",
       "      <td>1996</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102403623....</td>\n",
       "      <td>101102403623</td>\n",
       "      <td>1111027378004</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>19</td>\n",
       "      <td>31</td>\n",
       "      <td>1002.0</td>\n",
       "      <td>54602</td>\n",
       "      <td>183.51</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>中 19</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102406817....</td>\n",
       "      <td>101102406817</td>\n",
       "      <td>1111027377721</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>507.0</td>\n",
       "      <td>43124</td>\n",
       "      <td>117.57</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>中 6</td>\n",
       "      <td>2004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102407561....</td>\n",
       "      <td>101102407561</td>\n",
       "      <td>1111027376004</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>18</td>\n",
       "      <td>25</td>\n",
       "      <td>578.0</td>\n",
       "      <td>94988</td>\n",
       "      <td>60.85</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 6</td>\n",
       "      <td>1985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102414124....</td>\n",
       "      <td>101102414124</td>\n",
       "      <td>1111027378998</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>16</td>\n",
       "      <td>87</td>\n",
       "      <td>386.0</td>\n",
       "      <td>118007</td>\n",
       "      <td>32.71</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>中 12</td>\n",
       "      <td>2005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102414846....</td>\n",
       "      <td>101102414846</td>\n",
       "      <td>1111027380971</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>15</td>\n",
       "      <td>27</td>\n",
       "      <td>290.0</td>\n",
       "      <td>38657</td>\n",
       "      <td>75.02</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>顶 6</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102418928....</td>\n",
       "      <td>101102418928</td>\n",
       "      <td>1111027375904</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>14</td>\n",
       "      <td>60</td>\n",
       "      <td>174.0</td>\n",
       "      <td>51541</td>\n",
       "      <td>33.76</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 18</td>\n",
       "      <td>2010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102420495....</td>\n",
       "      <td>101102420495</td>\n",
       "      <td>1111027375203</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>13</td>\n",
       "      <td>96</td>\n",
       "      <td>361.0</td>\n",
       "      <td>93767</td>\n",
       "      <td>38.50</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 4</td>\n",
       "      <td>1979</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102427922....</td>\n",
       "      <td>101102427922</td>\n",
       "      <td>1111027376159</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>11</td>\n",
       "      <td>38</td>\n",
       "      <td>585.0</td>\n",
       "      <td>70482</td>\n",
       "      <td>83.00</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>高 17</td>\n",
       "      <td>1987</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102430595....</td>\n",
       "      <td>101102430595</td>\n",
       "      <td>1111027376834</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>10</td>\n",
       "      <td>75</td>\n",
       "      <td>254.0</td>\n",
       "      <td>29152</td>\n",
       "      <td>87.13</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>低 22</td>\n",
       "      <td>2008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102433507....</td>\n",
       "      <td>101102433507</td>\n",
       "      <td>1111027380042</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>378.0</td>\n",
       "      <td>33002</td>\n",
       "      <td>114.54</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>顶 6</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102437883....</td>\n",
       "      <td>101102437883</td>\n",
       "      <td>1111027378968</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>7</td>\n",
       "      <td>20</td>\n",
       "      <td>222.0</td>\n",
       "      <td>39728</td>\n",
       "      <td>55.88</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>顶 6</td>\n",
       "      <td>1997</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102438759....</td>\n",
       "      <td>101102438759</td>\n",
       "      <td>1111027375384</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>530.0</td>\n",
       "      <td>44419</td>\n",
       "      <td>119.32</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>底 6</td>\n",
       "      <td>2006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102439295....</td>\n",
       "      <td>101102439295</td>\n",
       "      <td>1111027376788</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>190.0</td>\n",
       "      <td>20128</td>\n",
       "      <td>94.40</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>底 6</td>\n",
       "      <td>1998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102441114....</td>\n",
       "      <td>101102441114</td>\n",
       "      <td>1111027374970</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>6</td>\n",
       "      <td>23</td>\n",
       "      <td>305.0</td>\n",
       "      <td>50547</td>\n",
       "      <td>60.34</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>高 18</td>\n",
       "      <td>1999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102445248....</td>\n",
       "      <td>101102445248</td>\n",
       "      <td>1111027379066</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>277.0</td>\n",
       "      <td>41699</td>\n",
       "      <td>66.43</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 9</td>\n",
       "      <td>2006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102446345....</td>\n",
       "      <td>101102446345</td>\n",
       "      <td>1111052073923</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>37495</td>\n",
       "      <td>46.14</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>顶 6</td>\n",
       "      <td>1990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>https://bj.lianjia.com/chengjiao/101102451242....</td>\n",
       "      <td>101102451242</td>\n",
       "      <td>1111027381533</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>607.0</td>\n",
       "      <td>80729</td>\n",
       "      <td>75.19</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>中 22</td>\n",
       "      <td>2003</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 链家网址            id  \\\n",
       "0   https://bj.lianjia.com/chengjiao/101101594408....  101101594408   \n",
       "1   https://bj.lianjia.com/chengjiao/101101685048....  101101685048   \n",
       "2   https://bj.lianjia.com/chengjiao/101101711072....  101101711072   \n",
       "3   https://bj.lianjia.com/chengjiao/101101814992....  101101814992   \n",
       "4   https://bj.lianjia.com/chengjiao/101101843015....  101101843015   \n",
       "5   https://bj.lianjia.com/chengjiao/101101866373....  101101866373   \n",
       "6   https://bj.lianjia.com/chengjiao/101101976063....  101101976063   \n",
       "7   https://bj.lianjia.com/chengjiao/101102047604....  101102047604   \n",
       "8   https://bj.lianjia.com/chengjiao/101102073737....  101102073737   \n",
       "9   https://bj.lianjia.com/chengjiao/101102087081....  101102087081   \n",
       "10  https://bj.lianjia.com/chengjiao/101102111185....  101102111185   \n",
       "11  https://bj.lianjia.com/chengjiao/101102158470....  101102158470   \n",
       "12  https://bj.lianjia.com/chengjiao/101102196240....  101102196240   \n",
       "13  https://bj.lianjia.com/chengjiao/101102213253....  101102213253   \n",
       "14  https://bj.lianjia.com/chengjiao/101102220650....  101102220650   \n",
       "15  https://bj.lianjia.com/chengjiao/101102231187....  101102231187   \n",
       "16  https://bj.lianjia.com/chengjiao/101102234186....  101102234186   \n",
       "17  https://bj.lianjia.com/chengjiao/101102244732....  101102244732   \n",
       "18  https://bj.lianjia.com/chengjiao/101102257575....  101102257575   \n",
       "19  https://bj.lianjia.com/chengjiao/101102278923....  101102278923   \n",
       "20  https://bj.lianjia.com/chengjiao/101102296349....  101102296349   \n",
       "21  https://bj.lianjia.com/chengjiao/101102305206....  101102305206   \n",
       "22  https://bj.lianjia.com/chengjiao/101102331601....  101102331601   \n",
       "23  https://bj.lianjia.com/chengjiao/101102338279....  101102338279   \n",
       "24  https://bj.lianjia.com/chengjiao/101102345112....  101102345112   \n",
       "25  https://bj.lianjia.com/chengjiao/101102363365....  101102363365   \n",
       "26  https://bj.lianjia.com/chengjiao/101102373488....  101102373488   \n",
       "27  https://bj.lianjia.com/chengjiao/101102383096....  101102383096   \n",
       "28  https://bj.lianjia.com/chengjiao/101102383680....  101102383680   \n",
       "29  https://bj.lianjia.com/chengjiao/101102391715....  101102391715   \n",
       "30  https://bj.lianjia.com/chengjiao/101102395736....  101102395736   \n",
       "31  https://bj.lianjia.com/chengjiao/101102403623....  101102403623   \n",
       "32  https://bj.lianjia.com/chengjiao/101102406817....  101102406817   \n",
       "33  https://bj.lianjia.com/chengjiao/101102407561....  101102407561   \n",
       "34  https://bj.lianjia.com/chengjiao/101102414124....  101102414124   \n",
       "35  https://bj.lianjia.com/chengjiao/101102414846....  101102414846   \n",
       "36  https://bj.lianjia.com/chengjiao/101102418928....  101102418928   \n",
       "37  https://bj.lianjia.com/chengjiao/101102420495....  101102420495   \n",
       "38  https://bj.lianjia.com/chengjiao/101102427922....  101102427922   \n",
       "39  https://bj.lianjia.com/chengjiao/101102430595....  101102430595   \n",
       "40  https://bj.lianjia.com/chengjiao/101102433507....  101102433507   \n",
       "41  https://bj.lianjia.com/chengjiao/101102437883....  101102437883   \n",
       "42  https://bj.lianjia.com/chengjiao/101102438759....  101102438759   \n",
       "43  https://bj.lianjia.com/chengjiao/101102439295....  101102439295   \n",
       "44  https://bj.lianjia.com/chengjiao/101102441114....  101102441114   \n",
       "45  https://bj.lianjia.com/chengjiao/101102445248....  101102445248   \n",
       "46  https://bj.lianjia.com/chengjiao/101102446345....  101102446345   \n",
       "47  https://bj.lianjia.com/chengjiao/101102451242....  101102451242   \n",
       "\n",
       "           所在社区编号       交易时间  挂牌天数  关注人数      总价    平米均价      面积  卧室  客厅  厨房  \\\n",
       "0   1111027379032 2018-01-03   231     9   507.0   36071  140.56   3   2   1   \n",
       "1   1111052857099 2018-01-03   208    38   305.0   34731   87.82   2   1   1   \n",
       "2   1111027375945 2018-01-03   200   313   665.0   49013  135.68   3   1   1   \n",
       "3   1111027374762 2018-01-03   173    82  1460.0   80896  180.48   3   1   1   \n",
       "4   1111027378386 2018-01-03   167   370   410.0   60065   68.26   2   1   1   \n",
       "5   1111027375613 2018-01-03   160   111  1148.0   79767  143.92   3   2   1   \n",
       "6   1111027374693 2018-01-03   136   176   168.0   31663   53.06   1   1   1   \n",
       "7   1111027376959 2018-01-03   119   144   610.0  115750   52.70   2   1   1   \n",
       "8   1111045368414 2018-01-03   113   130   211.0   42739   49.37   1   1   1   \n",
       "9   1111027377889 2018-01-03   109    67   250.0   42453   58.89   1   1   1   \n",
       "10  1111027382608 2018-01-03   103    33   410.0   36795  111.43   2   1   1   \n",
       "11  1111027381711 2018-01-03    89    15  1655.0   89204  185.53   3   1   1   \n",
       "12  1111027379032 2018-01-03    80    71   330.0   36971   89.26   3   1   1   \n",
       "13  1111027382064 2018-01-03    75   132   510.0   90266   56.50   2   1   1   \n",
       "14  1111027382441 2018-01-03    73    56   666.0   81899   81.32   2   1   1   \n",
       "15  1111027381705 2018-01-03    70    41   940.0   60622  155.06   3   2   1   \n",
       "16  1111046997447 2018-01-03    70    52   300.0   33857   88.61   3   2   1   \n",
       "17  1111027378724 2018-01-03    67     0   222.0   60000   37.00   1   1   1   \n",
       "18  1111027377467 2018-01-03    64    89   400.0   53982   74.10   2   2   1   \n",
       "19  1111027375273 2018-01-03    58    21   479.0   56923   84.15   2   1   1   \n",
       "20  1111027380074 2018-01-03    53   106   217.0   42516   51.04   1   1   1   \n",
       "21  1111027378131 2018-01-03    50   254   330.0   52216   63.20   1   1   1   \n",
       "22  1111027381745 2018-01-03    41    61   440.0   37314  117.92   2   2   1   \n",
       "23  1111027373686 2018-01-03    39    24   595.0   80887   73.56   1   2   1   \n",
       "24  1111027377297 2018-01-03    37    40   396.0   51826   76.41   2   1   1   \n",
       "25  1111027381444 2018-01-03    32    38   222.5   40647   54.74   2   1   1   \n",
       "26  1111027381702 2018-01-03    29   118   568.0   55917  101.58   2   1   1   \n",
       "27  1111027381067 2018-01-03    26    14   350.0   70708   49.50   2   1   1   \n",
       "28  1111027378890 2018-01-03    25    30   431.0   67672   63.69   1   1   1   \n",
       "29  1111027381705 2018-01-03    23    82   386.0   60626   63.67   2   1   1   \n",
       "30  1111027381735 2018-01-03    22     9   590.0   58163  101.44   3   1   1   \n",
       "31  1111027378004 2018-01-03    19    31  1002.0   54602  183.51   4   1   1   \n",
       "32  1111027377721 2018-01-03    18     0   507.0   43124  117.57   3   1   1   \n",
       "33  1111027376004 2018-01-03    18    25   578.0   94988   60.85   2   1   1   \n",
       "34  1111027378998 2018-01-03    16    87   386.0  118007   32.71   1   1   1   \n",
       "35  1111027380971 2018-01-03    15    27   290.0   38657   75.02   2   1   1   \n",
       "36  1111027375904 2018-01-03    14    60   174.0   51541   33.76   1   0   1   \n",
       "37  1111027375203 2018-01-03    13    96   361.0   93767   38.50   1   1   1   \n",
       "38  1111027376159 2018-01-03    11    38   585.0   70482   83.00   3   1   1   \n",
       "39  1111027376834 2018-01-03    10    75   254.0   29152   87.13   2   1   1   \n",
       "40  1111027380042 2018-01-03     9    11   378.0   33002  114.54   2   2   1   \n",
       "41  1111027378968 2018-01-03     7    20   222.0   39728   55.88   2   1   1   \n",
       "42  1111027375384 2018-01-03     7     0   530.0   44419  119.32   3   1   1   \n",
       "43  1111027376788 2018-01-03     7     0   190.0   20128   94.40   2   2   1   \n",
       "44  1111027374970 2018-01-03     6    23   305.0   50547   60.34   1   1   1   \n",
       "45  1111027379066 2018-01-03     5     0   277.0   41699   66.43   1   1   1   \n",
       "46  1111052073923 2018-01-03     4     0   173.0   37495   46.14   1   1   1   \n",
       "47  1111027381533 2018-01-03     2     0   607.0   80729   75.19   2   1   1   \n",
       "\n",
       "    浴室  楼层信息  建成时间  \n",
       "0    2   中 6  2009  \n",
       "1    1  高 14  2012  \n",
       "2    2  中 28  2008  \n",
       "3    2  中 32  2011  \n",
       "4    1   顶 6  2000  \n",
       "5    2  中 11  2005  \n",
       "6    1  中 23  2008  \n",
       "7    1   底 5  1981  \n",
       "8    1  高 15  2012  \n",
       "9    1   低 6  1995  \n",
       "10   1  中 11  2006  \n",
       "11   2  中 16  2001  \n",
       "12   1  中 20  2010  \n",
       "13   1   中 5  1973  \n",
       "14   1  中 24  2011  \n",
       "15   2  中 29  2005  \n",
       "16   1  低 16  2014  \n",
       "17   1  中 15  1991  \n",
       "18   1   低 6  2004  \n",
       "19   1  低 28  2009  \n",
       "20   1   高 6  1997  \n",
       "21   1  中 11  2011  \n",
       "22   2   中 6  2002  \n",
       "23   1  中 21  2006  \n",
       "24   1  中 28  2008  \n",
       "25   1   中 6  1993  \n",
       "26   1  低 29  2002  \n",
       "27   1   中 6  1992  \n",
       "28   1  低 16  2008  \n",
       "29   1   中 6  1990  \n",
       "30   1  中 16  1996  \n",
       "31   2  中 19  1995  \n",
       "32   2   中 6  2004  \n",
       "33   1   中 6  1985  \n",
       "34   2  中 12  2005  \n",
       "35   1   顶 6  2000  \n",
       "36   1  中 18  2010  \n",
       "37   1   中 4  1979  \n",
       "38   1  高 17  1987  \n",
       "39   1  低 22  2008  \n",
       "40   2   顶 6  2000  \n",
       "41   1   顶 6  1997  \n",
       "42   1   底 6  2006  \n",
       "43   1   底 6  1998  \n",
       "44   1  高 18  1999  \n",
       "45   1   中 9  2006  \n",
       "46   1   顶 6  1990  \n",
       "47   1  中 22  2003  "
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df08"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "senior-mistress",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
